UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kh0gsgViAffzR87Kf6NdCEtt0/fRpZ+w3gl2Av1lHZ8='
WHERE
key_id = 'e7e5cb501665db2daa96125ed07c94009500ebae0312fe0dfbbd397b89646340'
AND (
token = 'kh0gsgViAffzR87Kf6NdCEtt0/fRpZ+w3gl2Av1lHZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)