UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tSfN9VE19KSbl1tQqeDGrW+SZ9ey2mAi4lUKCAomMlg='
WHERE
key_id = 'e4e2768741ec8229c0a8bc98b2b6077385289131a835fdf61a8f6a2ff26e2138'
AND (
token = 'tSfN9VE19KSbl1tQqeDGrW+SZ9ey2mAi4lUKCAomMlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)