UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MhPXlj4p4YB1oUf5Y3e0lT6XhGECtgNB1voLOUpnkns='
WHERE
key_id = '2c12f544c8b07c0affcc45204736230499bb365b0b4193dab618cee9064cbff9'
AND (
token = 'MhPXlj4p4YB1oUf5Y3e0lT6XhGECtgNB1voLOUpnkns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)