UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RcifH8KQI44RjaSAdL4XLGMkxtJ8PbZ+a54YF32qRgE='
WHERE
key_id = '4e40ae6c3969c32f2c0fee77a57bc8ad6f97c25d51738318085642f4e153b5dc'
AND (
token = 'RcifH8KQI44RjaSAdL4XLGMkxtJ8PbZ+a54YF32qRgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)