UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpQyzBHvBeE+Kr0xQUBda9f3yoElYGrAJ09SPbkAXcI='
WHERE
key_id = 'dd809ba67ce6e49076268e5a983c3f05546fd6931be9716d84ed6b2ccc227741'
AND (
token = 'XpQyzBHvBeE+Kr0xQUBda9f3yoElYGrAJ09SPbkAXcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)