UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JkzIwcArnnoy+RJ8ZRStJb2mSMuiJ0V82bwbA+6KKRU='
WHERE
key_id = '402a3cf7814e297c89f6526e231300d28dace4654acc717d86c40aba8be01033'
AND (
token = 'JkzIwcArnnoy+RJ8ZRStJb2mSMuiJ0V82bwbA+6KKRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)