UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRBidxKji3l/BBBObaDEht45+FM4Wqnbmampr7dOcUM='
WHERE
key_id = 'a27e0e8b988fe29c11a80c79228770a0fa3a49ebb25a8101cd00a43cfd895c5a'
AND (
token = 'HRBidxKji3l/BBBObaDEht45+FM4Wqnbmampr7dOcUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)