UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rshZ9p3UVGgQP87OrBPiS/2CoYII/v4Dsiqr0aihdEQ='
WHERE
key_id = '0c684f418750926b83879bfa51086dde75d6b95a20cec8380658aedf80e60b04'
AND (
token = 'rshZ9p3UVGgQP87OrBPiS/2CoYII/v4Dsiqr0aihdEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)