UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCvdX+YUYqMlAi7hjkHMOMmOSc/yHjEkn1NtCc4Ib+c='
WHERE
key_id = 'c1a13f5659b2366e0709fbe51ad40f2a1d1a6202978794a2fdf5f3447ce7a461'
AND (
token = 'mCvdX+YUYqMlAi7hjkHMOMmOSc/yHjEkn1NtCc4Ib+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)