UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DYw9PKr0CjgYIE1j1fzXXXDd2206hiypOhmSw+kMkB4='
WHERE
key_id = '231645d8af67fb29c369642de8a1235e8f4f3229a7c9cb488396ae2993fbf552'
AND (
token = 'DYw9PKr0CjgYIE1j1fzXXXDd2206hiypOhmSw+kMkB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)